UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QR1eG2zUVyMuVRdpgf43TV0M1M8yhviNbMfwttYeL30='
WHERE
key_id = '96b43d21acd90d2a8f05ab2856643306494e5eb31f727642f10361b7afb0b1e2'
AND (
token = 'QR1eG2zUVyMuVRdpgf43TV0M1M8yhviNbMfwttYeL30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)