UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tMVdt9Ab2HLasIE6y2g2DfGpQi8EE0ZUJoyuTA8AV2M=' 
WHERE 
  key_id = '66ed30cc23c9210fa103cec64af433feee2583a45d6ad08072ed6ee9bfda3674' 
  AND (
    token = 'tMVdt9Ab2HLasIE6y2g2DfGpQi8EE0ZUJoyuTA8AV2M=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00011