UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vVdpTLg2pL5yH8QidYMwwKpKihIvP/ihhkuyC0g9njs='
WHERE
key_id = '7291c4ff68cb8e521e4e0119f8586a1b2e035195766b9f5b659ae4374bda012a'
AND (
token = 'vVdpTLg2pL5yH8QidYMwwKpKihIvP/ihhkuyC0g9njs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)