UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8v+9Jobs10Z+eT0mttaIwXmnanMgf+c04JAC3D/fHVY=' 
WHERE 
  key_id = 'd8788daecfa85942cedc552f138521c66d8e97604e536bb52eab860f87f8c8f8' 
  AND (
    token = '8v+9Jobs10Z+eT0mttaIwXmnanMgf+c04JAC3D/fHVY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027