UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bcnR6kFjvSESb3belwGHTHocqIYWF7XroD4JKX+ckAs=' 
WHERE 
  key_id = '84b30c283476b8c8401303de47b0245a15dfbcf1aed161f03f93c9d70c5ff595' 
  AND (
    token = 'bcnR6kFjvSESb3belwGHTHocqIYWF7XroD4JKX+ckAs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022