UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlZ95tBlm6A3OD0HolpCpvdWiAZj0moANci6+qaODuI='
WHERE
key_id = 'aa4d21c8cb828f18e7ee2cf321130de053a6c90b458616c172be9a638571f23a'
AND (
token = 'ZlZ95tBlm6A3OD0HolpCpvdWiAZj0moANci6+qaODuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)