UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zjMqcxl+0Ep1J9L7gKEuEleHL6j7YvyXFjK1b/B0ssI='
WHERE
key_id = '9b48a63c0a9f0eacbad4eb972ea7074e735cb564bfd1b92ed24c2aad8ac2527a'
AND (
token = 'zjMqcxl+0Ep1J9L7gKEuEleHL6j7YvyXFjK1b/B0ssI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)