UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'B9H2TDI+ExigPTu8W14kZGCqz1ZtWZBFnP4Yj3pkHFc=' 
WHERE 
  key_id = '7dc32d9c7c4b83294640cb90b85a3bff2c203c1a649d307cdb038117ff9fdf8e' 
  AND (
    token = 'B9H2TDI+ExigPTu8W14kZGCqz1ZtWZBFnP4Yj3pkHFc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042