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