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