UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1zCPSAHjqZopaxPPPZIZpR4p5SX0G8CUnNye6Z3oOJA='
WHERE
key_id = 'd8c6af6932ebf16da52c433370c07712dd4732cd139a4e3f5664f93e4c91d1bc'
AND (
token = '1zCPSAHjqZopaxPPPZIZpR4p5SX0G8CUnNye6Z3oOJA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)