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