UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L7l6yaA8pd80tbT3TqMKZfWasOEbIoh3WqvQ7veYSAY='
WHERE
key_id = '1a9584618d89db2a5bdd112821a5f7f0f8297a58fd672d98b0c872717d34da03'
AND (
token = 'L7l6yaA8pd80tbT3TqMKZfWasOEbIoh3WqvQ7veYSAY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)