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