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