UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QtJXL10Q50rlAaJX3rjxx561YW9zeEOq+zhev5mVJGc=' 
WHERE 
  key_id = '4ca0f83040fbec2d09e3e11d8003d71c40eca4a1bbc030746285f364a0034f5e' 
  AND (
    token = 'QtJXL10Q50rlAaJX3rjxx561YW9zeEOq+zhev5mVJGc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042