UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DHOGk+htmh6sLEPuup7O3k5y5t8GTr/uIVBWxY5XPDY=' 
WHERE 
  key_id = 'f028899cbf7480652c9f1289b0a10a8f5417e157a25c0174905f12234566074c' 
  AND (
    token = 'DHOGk+htmh6sLEPuup7O3k5y5t8GTr/uIVBWxY5XPDY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038