UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Revn28pzt1jYC6WuTisGGDZX2GEgZWMtQDJY+5ze964='
WHERE
key_id = 'b817b1e2b5d41cb1cd19af36ecaa0a989d760811ddaa75f75a5e78f536b696f4'
AND (
token = 'Revn28pzt1jYC6WuTisGGDZX2GEgZWMtQDJY+5ze964='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)