UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DxqrH1zW71w5IRhhWClyKG0iWsqiOriEeCuh1ZT7z3o='
WHERE
key_id = '0005b314b737ab5628a44a7b4abc20221f435f8d7979d35a441b9056a65bcae7'
AND (
token = 'DxqrH1zW71w5IRhhWClyKG0iWsqiOriEeCuh1ZT7z3o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)