UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vAfnUdfVK24B2UrjfKZcSiY6nfXuvZwLoQJ0sj0AlUI='
WHERE
key_id = 'a25a33a97a726434c675c60219020669321eb00c5f8a596da5cc0c753f6e1304'
AND (
token = 'vAfnUdfVK24B2UrjfKZcSiY6nfXuvZwLoQJ0sj0AlUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)