UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrD0VErfPoyG2QXstHy7XRwSwT9k+0RD7CUbQZoY8Ys='
WHERE
key_id = '87506e9b075e0a76ffcc5a72f0daa6b9b45a8accc6cb79339b07866474176364'
AND (
token = 'ZrD0VErfPoyG2QXstHy7XRwSwT9k+0RD7CUbQZoY8Ys='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)