UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Qjn+AybWt5KHUtEM6e2SGuxYCYIFur40MWJH5Nu7OCw=' 
WHERE 
  key_id = '553637aa867a7fcb891364988e4af090d17cbfb03a51f92796fb264daf786cd9' 
  AND (
    token = 'Qjn+AybWt5KHUtEM6e2SGuxYCYIFur40MWJH5Nu7OCw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033