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