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