UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xL7LEa45gfC2tfi4UpNo5Zb+xUu1K5Ot/xpCfLK5DyI=' 
WHERE 
  key_id = 'efba072513de7154485f8b70e91cb825da07dab9b71a4bfc0e2d411c875eba9f' 
  AND (
    token = 'xL7LEa45gfC2tfi4UpNo5Zb+xUu1K5Ot/xpCfLK5DyI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048