UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8bfEy38nj16LQfC8bQzNYgO5gpfpMCiHVy0aSBOFoPA='
WHERE
key_id = '6eefe506025608a12ffead886c04b87ff01fa6a95f5afb157824ad97bd482ff5'
AND (
token = '8bfEy38nj16LQfC8bQzNYgO5gpfpMCiHVy0aSBOFoPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)