UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'USizWSX7sVe7GLjkpR6yZ3sy194vW6hdFDlLb76EDsI=' 
WHERE 
  key_id = '1096f33e83c2f898d4c796575c4a827d3bb285b9d863dbfcaeb2d7cb8f69a83f' 
  AND (
    token = 'USizWSX7sVe7GLjkpR6yZ3sy194vW6hdFDlLb76EDsI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033