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