UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQa8XIKHU8N0OWRaArqIJ1ydZoQmA9+SQ7mZs6uDA5Y='
WHERE
key_id = 'd5103b929a13eb1593968a3b0c92b6d634e198228df820090c0a441f35907237'
AND (
token = 'CQa8XIKHU8N0OWRaArqIJ1ydZoQmA9+SQ7mZs6uDA5Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)