UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'maV+WqleAPZzR8GHk+kkt/C4hus75N/TgNwGYfdCysM=' 
WHERE 
  key_id = 'a73fbd8f015a6da29a890b13bc27dd8a18ed1be2ad9bb214363c0fab316f1f8d' 
  AND (
    token = 'maV+WqleAPZzR8GHk+kkt/C4hus75N/TgNwGYfdCysM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027