UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zpEf5cUKW8RLQg3UKHdb57y9aVtC+yG7hTXW6rz7Ptk='
WHERE
key_id = 'a7db80fa3ea7f412632d360502610107cef0a4ffa826a19bac8d54945ce39210'
AND (
token = 'zpEf5cUKW8RLQg3UKHdb57y9aVtC+yG7hTXW6rz7Ptk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)