UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZvX3E2bPfRixeC2EVwpI7BTP7BjUK9DkaPg8jQgask='
WHERE
key_id = '348f432cf6f9f842fdc00a5973b69e4fe62747d1c30ac6b9ce0e7ef84e4a19c3'
AND (
token = 'nZvX3E2bPfRixeC2EVwpI7BTP7BjUK9DkaPg8jQgask='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)