UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KaHNGk/dxe4iO8ditGEtSDrwt36M9TmmHK1M0yzSZsY=' 
WHERE 
  key_id = 'd8f34ddf607c7f3fb637c0d1575cf3119f3236c461e428a7a72b3ae4274f0200' 
  AND (
    token = 'KaHNGk/dxe4iO8ditGEtSDrwt36M9TmmHK1M0yzSZsY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036