UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VoSW4y0BAgcsJZKFLnsS5rMN1JiI+Gpm42W4N/Lcu3A=' 
WHERE 
  key_id = '2f348e5b41a15e81c880056b9f60c42c3314a7e7ea5967d735b3fb2ae0815560' 
  AND (
    token = 'VoSW4y0BAgcsJZKFLnsS5rMN1JiI+Gpm42W4N/Lcu3A=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026