UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nd4SC8zS4BJ9q1tcT9DrWdrWiwFfC1fJkMGU/MYKRtQ='
WHERE
key_id = 'c6c807978ee431851b4afd77727b4b22a536ca1aaac173aec2040448aeaf775a'
AND (
token = 'Nd4SC8zS4BJ9q1tcT9DrWdrWiwFfC1fJkMGU/MYKRtQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)