UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g3n1vLAPgr1D0mjvZ25VldRsCZWpoXw7Og1ice8zze8='
WHERE
key_id = '8e5a8649264605f8b21b054e52a75451e2558f4a5425ca0f984cae6062eca2d4'
AND (
token = 'g3n1vLAPgr1D0mjvZ25VldRsCZWpoXw7Og1ice8zze8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)