UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VNy1558q1gv+5dqaEreWK/YvBVZse+7T9MWmeJYdwGA=' 
WHERE 
  key_id = '8603b1f5450521ce8eb107a8569e204eff9261e480a181cc60940a6924815627' 
  AND (
    token = 'VNy1558q1gv+5dqaEreWK/YvBVZse+7T9MWmeJYdwGA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019