UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/xpVWPjcPfnUoZgl+zDH7wwdUapK/72lMCbbsAxSGY8='
WHERE
key_id = 'f7bfd3540cbb0d28a7eeadacf86bce06294fd11df1b4d68dfc5c1188e023dbab'
AND (
token = '/xpVWPjcPfnUoZgl+zDH7wwdUapK/72lMCbbsAxSGY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)