UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fFD9MX2wUvhA2neeGJnTJLJEUYUIiTJg20p1sedzGoQ='
WHERE
key_id = '0d4eb2c221306dc949e14cd9e5ba44a04396ef0bcb4e69f8bc2072bad5d21354'
AND (
token = 'fFD9MX2wUvhA2neeGJnTJLJEUYUIiTJg20p1sedzGoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)