UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L0RJfESLCPqfX4iNcmBHLHFxRmA0rdbAhik5gUvXjfE='
WHERE
key_id = '9c3cd3b473f7e8dde387232a7ecc7132780886df71d15d58e83d4a119b2a1a3d'
AND (
token = 'L0RJfESLCPqfX4iNcmBHLHFxRmA0rdbAhik5gUvXjfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)